{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Help","Projects","DROPDOWNS","Unit Costs","Assumptions","Cross-Sections","Cross-Section Comparison","Template","1","2"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":51,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Help","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Help",null,null,"Back to Projects Tab"]
[]
["Purpose of this Spreadsheet"]
["· Most cities have a different amount of transportation projects"]
["· This is designed to organize projects in an easy to read manner"]
["· It is designed to easily input projects and update the fields"]
[]
["How to use this Spreadsheet"]
["1) Go to the Unit Costs Tab","1)"]
["2) Check the tables and make sure all the pricing and the percentages are correct."]
["3) Make sure the right city is selected."]
["          < If your city isn't there. Please input your city in the orange table on the drop down page"]
["4) Check the Assumptions and the Cross-Sections sheets and double check the numbers (just the ones in the orange cells)"]
["5) On the Projects page, Click on the Add Projects button to add a project","5)"]
["6) After the project has been added, check the dark blue numbers(Length of Segment and Existing ROW) to make sure they are correct.","Length"]
["7) On the projects tab, in the City% cell, input the value \"='number of the project'$E$34\" (Changing number of the project to the actual number."]
["8) On the projects tab, in the City total cell, input the value \"='number of the project'$E$35\" (Changing number of the project to the actual number."]

{"sheet":"Projects","index":1,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Help"]
[null,"Project Summary (All Projects)"]
[null,"Project","Location","Project Type","Total Price","Funding Source","Range (Yr)",{"$f":"'Unit Costs'!B1 & \" %\"","v":"Provo %"},{"$f":"'Unit Costs'!B1&\" Total\"","v":"Provo Total"}]
[null,1,"asdfafs","New",null,"City",10,{"$f":"'1'!$E$34","v":0.26638615391484843},{"$f":"'1'!$E$35","v":50000}]
[null,2,"new streets","New",null,"City",10,{"$f":"'2'!$E$34","v":0.26638615391484843},{"$f":"'2'!$E$35","v":90000}]

{"sheet":"DROPDOWNS","index":2,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Project Type","City %","Funding","Range (yr)","Cross-Sections",null,"Back to Projects Tab"]
[null,"New",null,"City",10,"Arterial"]
[null,"Capacity Improvement",1,"City/MAG",25,"5 ln Commercial Collector"]
[null,"Traffic Signal",1,"UDOT",null,"3 ln Commercial Collector"]
[null,"Roundabout",1,null,null,"Major Collector"]
[null,"Intersection Improvement",1,null,null,"Major Collector (No Bike)"]
[null,null,null,null,null,"Minor Collector (Add. ROW)"]
[null,null,null,null,null,"Minor Collector"]
[null,null,null,null,null,"Rural Street"]
[null,null,null,null,null,"Local Street"]
[]
[]
[]
[]
[]
[null,"Cities"]
[null,"Salt Lake"]
[null,"Salem"]
[null,"Provo"]
[null,"Orem"]
[null,"Layton"]

{"sheet":"Unit Costs","index":3,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,2,24,3],[0,1,0,3],[1,1,1,3],[2,1,2,3],[19,2,19,3],[21,2,21,3],[23,2,23,3]]}
[null,"Provo",null,null,null,1]
[null,"Transportation Improvement Program (TIP)"]
[null,"Unit Costs",null,null,null,null,"Back to Projects Tab"]
[null,"Item","Unit","Unit Cost"]
[null,"Parkstrip","S.F.",10]
[null,"Removal of Existing Asphalt","S.Y.",4]
[null,"Clearing and Grubbing","Acre",2000]
[null,"Roadway Excavation","C.Y.",10.5]
[null,"HMA Concrete","Ton",85]
[null,"Untreated Base Course","C.Y.",15]
[null,"Granular Borrow","C.Y.",40]
[null,"Curb and Gutter (2.5' width)","L.F.",22.5]
[null,"Sidewalk (4' width)","L.F.",25]
[null,"Drainage","L.F.",45]
[null,"Right of Way","S.F.",15]
[]
[null,"Bridge/Culvert","S.F.",225]
[null,"Traffic Signal","Each",180000]
[]
[null,"Contingency",0.25]
[]
[null,"Mobilization",0.1]
[]
[null,"Preconstruction Engineering",0.08]
[null,"Construction Engineering",0.08]

{"sheet":"Assumptions","index":4,"n_rows":12,"n_cols":17,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"HMA Pavement Density (pcf)","HMA Thickness (in)","Untreated Base Course Thickness (in)","Granual Borrow Thickness (in)","Roadway Excavation Depth (ft)","No. Sidewalks (No.)","Parkstrip","Roadway Width","Curb & Gutter","Sidewalk Width","X-Section Width","Impact Fee %",null,"Back to Projects Tab"]
[null,null,{"$f":"DROPDOWNS!F3","v":"Arterial"},155,4,8,14,2.5,2,{"$f":"'Cross-Sections'!D3","v":5},{"$f":"'Cross-Sections'!F3","v":81},{"$f":"'Cross-Sections'!E3","v":2.5},{"$f":"'Cross-Sections'!C3","v":5},{"$f":"'Cross-Sections'!K3","v":106},{"$f":"'Cross-Section Comparison'!AC32","v":0.26638615391484843}]
[null,null,{"$f":"DROPDOWNS!F4","v":"5 ln Commercial Collector"},155,4,8,14,2.5,2,{"$f":"'Cross-Sections'!D6","v":0},{"$f":"'Cross-Sections'!F6","v":78},{"$f":"'Cross-Sections'!E6","v":2},{"$f":"'Cross-Sections'!C6","v":6},{"$f":"'Cross-Sections'!K6","v":94},{"$f":"'Cross-Section Comparison'!Z32","v":0.17212639115919304}]
[null,null,{"$f":"DROPDOWNS!F5","v":"3 ln Commercial Collector"},155,4,8,14,2.5,2,{"$f":"'Cross-Sections'!D9","v":0},{"$f":"'Cross-Sections'!F9","v":54},{"$f":"'Cross-Sections'!E9","v":2},{"$f":"'Cross-Sections'!C9","v":6},{"$f":"'Cross-Sections'!K9","v":70},{"$f":"'Cross-Section Comparison'!X32","v":0}]
[null,null,{"$f":"DROPDOWNS!F6","v":"Major Collector"},155,4,8,14,2.5,2,{"$f":"'Cross-Sections'!D12","v":10},{"$f":"'Cross-Sections'!F12","v":58},{"$f":"'Cross-Sections'!E12","v":2},{"$f":"'Cross-Sections'!C12","v":5},{"$f":"'Cross-Sections'!K12","v":92},{"$f":"'Cross-Section Comparison'!T32","v":0.22343452735164604}]
[null,null,{"$f":"DROPDOWNS!F7","v":"Major Collector (No Bike)"},155,4,8,14,2.5,2,{"$f":"'Cross-Sections'!D15","v":10},{"$f":"'Cross-Sections'!F15","v":50},{"$f":"'Cross-Sections'!E15","v":2},{"$f":"'Cross-Sections'!C15","v":5},{"$f":"'Cross-Sections'!K15","v":84},{"$f":"'Cross-Section Comparison'!Q32","v":0.17191689530855014}]
[null,null,{"$f":"DROPDOWNS!F8","v":"Minor Collector (Add. ROW)"},155,4,8,14,2.5,2,{"$f":"'Cross-Sections'!D18","v":8},{"$f":"'Cross-Sections'!F18","v":38},{"$f":"'Cross-Sections'!E18","v":2},{"$f":"'Cross-Sections'!C18","v":5},{"$f":"'Cross-Sections'!K18","v":96},{"$f":"'Cross-Section Comparison'!N32","v":0.23145212303583063}]
[null,null,{"$f":"DROPDOWNS!F9","v":"Minor Collector"},155,4,8,14,2.5,2,{"$f":"'Cross-Sections'!D21","v":8},{"$f":"'Cross-Sections'!F21","v":38},{"$f":"'Cross-Sections'!E21","v":2},{"$f":"'Cross-Sections'!C21","v":5},{"$f":"'Cross-Sections'!K21","v":68},{"$f":"'Cross-Section Comparison'!K32","v":2.0336860847867899E-2}]
[null,null,{"$f":"DROPDOWNS!F10","v":"Rural Street"},155,3,8,14,2.5,2,{"$f":"'Cross-Sections'!D24","v":10},{"$f":"'Cross-Sections'!F24","v":40},{"$f":"'Cross-Sections'!E24","v":0},{"$f":"'Cross-Sections'!C24","v":5},{"$f":"'Cross-Sections'!K24","v":70},{"$f":"'Cross-Section Comparison'!H32","v":5.6959034898293903E-2}]
[null,null,{"$f":"DROPDOWNS!F11","v":"Local Street"},155,3,8,14,2.5,2,{"$f":"'Cross-Sections'!D27","v":8},{"$f":"'Cross-Sections'!F27","v":36},{"$f":"'Cross-Sections'!E27","v":2},{"$f":"'Cross-Sections'!C27","v":5},{"$f":"'Cross-Sections'!K27","v":66},{"$f":"'Cross-Section Comparison'!F32","v":0}]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]

{"sheet":"Cross-Sections","index":5,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[26,0,27,0],[26,10,27,10],[27,1,27,3],[27,4,27,6],[27,7,27,9],[20,0,21,0],[20,10,21,10],[21,1,21,3],[21,4,21,6],[21,7,21,9],[23,0,24,0],[23,10,24,10],[24,1,24,3],[24,4,24,6],[24,7,24,9],[14,0,15,0],[14,10,15,10],[15,1,15,3],[15,4,15,6],[15,7,15,9],[17,0,18,0],[17,10,18,10],[18,1,18,3],[18,4,18,6],[18,7,18,9],[8,0,9,0],[8,10,9,10],[9,1,9,3],[9,4,9,6],[9,7,9,9],[11,0,12,0],[11,10,12,10],[12,1,12,3],[12,4,12,6],[12,7,12,9],[2,0,3,0],[2,10,3,10],[3,1,3,3],[3,4,3,6],[3,7,3,9],[5,0,6,0],[5,10,6,10],[6,1,6,3],[6,4,6,6],[6,7,6,9]]}
[null,"P.U.E","Sidewalk","Parkstrip","Curb&Gut","Roadway","Curb&Gut","Parkstrip","Sidewalk","P.U.E","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Back to Projects Tab"]
[{"$f":"DROPDOWNS!F3","v":"Arterial"},0,5,5,2.5,81,2.5,5,5,0,{"$f":"SUM(B4:J4)","v":106}]
[null,{"$f":"SUM(B3:D3)","v":10},null,null,{"$f":"SUM(E3:G3)","v":86},null,null,{"$f":"SUM(H3:J3)","v":10}]
[]
[{"$f":"DROPDOWNS!F4","v":"5 ln Commercial Collector"},0,6,0,2,78,2,0,6,0,{"$f":"SUM(B7:J7)","v":94}]
[null,{"$f":"SUM(B6:D6)","v":6},null,null,{"$f":"SUM(E6:G6)","v":82},null,null,{"$f":"SUM(H6:J6)","v":6}]
[]
[{"$f":"DROPDOWNS!F5","v":"3 ln Commercial Collector"},0,6,0,2,54,2,0,6,0,{"$f":"SUM(B10:J10)","v":70}]
[null,{"$f":"SUM(B9:D9)","v":6},null,null,{"$f":"SUM(E9:G9)","v":58},null,null,{"$f":"SUM(H9:J9)","v":6}]
[]
[{"$f":"DROPDOWNS!F6","v":"Major Collector"},0,5,10,2,58,2,10,5,0,{"$f":"SUM(B13:J13)","v":92}]
[null,{"$f":"SUM(B12:D12)","v":15},null,null,{"$f":"SUM(E12:G12)","v":62},null,null,{"$f":"SUM(H12:J12)","v":15}]
[]
[{"$f":"DROPDOWNS!F7","v":"Major Collector (No Bike)"},0,5,10,2,50,2,10,5,0,{"$f":"SUM(B16:J16)","v":84}]
[null,{"$f":"SUM(B15:D15)","v":15},null,null,{"$f":"SUM(E15:G15)","v":54},null,null,{"$f":"SUM(H15:J15)","v":15}]
[]
[{"$f":"DROPDOWNS!F8","v":"Minor Collector (Add. ROW)"},14,5,8,2,38,2,8,5,14,{"$f":"SUM(B19:J19)","v":96}]
[null,{"$f":"SUM(B18:D18)","v":27},null,null,{"$f":"SUM(E18:G18)","v":42},null,null,{"$f":"SUM(H18:J18)","v":27}]
[]
[{"$f":"DROPDOWNS!F9","v":"Minor Collector"},0,5,8,2,38,2,8,5,0,{"$f":"SUM(B22:J22)","v":68}]
[null,{"$f":"SUM(B21:D21)","v":13},null,null,{"$f":"SUM(E21:G21)","v":42},null,null,{"$f":"SUM(H21:J21)","v":13}]
[]
[{"$f":"DROPDOWNS!F10","v":"Rural Street"},0,5,10,0,40,0,10,5,0,{"$f":"SUM(B25:J25)","v":70}]
[null,{"$f":"SUM(B24:D24)","v":15},null,null,{"$f":"SUM(E24:G24)","v":40},null,null,{"$f":"SUM(H24:J24)","v":15}]
[]
[{"$f":"DROPDOWNS!F11","v":"Local Street"},0,5,8,2,36,2,8,5,0,{"$f":"SUM(B28:J28)","v":66}]
[null,{"$f":"SUM(B27:D27)","v":13},null,null,{"$f":"SUM(E27:G27)","v":40},null,null,{"$f":"SUM(H27:J27)","v":13}]

{"sheet":"Cross-Section Comparison","index":6,"n_rows":50,"n_cols":32,"rows_kept":50,"cut":false,"hidden":false,"merged":[[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[28,0,28,2],[30,0,30,2],[31,0,31,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[26,0,26,2],[0,0,0,29],[1,0,1,29],[2,4,3,5],[2,7,3,8],[2,10,3,11],[2,13,3,14],[2,16,3,17],[2,19,3,20],[2,22,3,23],[2,25,3,26],[2,28,3,29],[19,0,19,2],[21,0,21,2],[23,0,23,2],[25,0,25,2]]}
[{"$f":"'Unit Costs'!B1&\" TMP\"","v":"Provo TMP"}]
["Developer's Responsibility vs. City's Responsibility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to Projects Tab"]
[null,null,5,null,{"$f":"\"100' Length of \" & DROPDOWNS!F11","v":"100' Length of Local Street"},null,null,{"$f":"\"100' Length of \" & DROPDOWNS!F10","v":"100' Length of Rural Street"},null,null,{"$f":"\"100' Length of \" & DROPDOWNS!F9","v":"100' Length of Minor Collector"},null,null,{"$f":"\"100' Length of \" & DROPDOWNS!F8","v":"100' Length of Minor Collector (Add. ROW)"},null,null,{"$f":"\"100' Length of \" & DROPDOWNS!F7","v":"100' Length of Major Collector (No Bike)"},null,null,{"$f":"\"100' Length of \" & DROPDOWNS!F6","v":"100' Length of Major Collector"},null,null,{"$f":"\"100' Length of \" & DROPDOWNS!F5","v":"100' Length of 3 ln Commercial Collector"},null,null,{"$f":"\"100' Length of \" & DROPDOWNS!F4","v":"100' Length of 5 ln Commercial Collector"},null,null,{"$f":"\"100' Length of \" & DROPDOWNS!F3","v":"100' Length of Arterial"}]
[]
["Item","Unit","Unit Cost",null,"Quantity","Cost",null,"Quantity","Cost",null,"Quantity","Cost",null,"Quantity","Cost",null,"Quantity","Cost",null,"Quantity","Cost",null,"Quantity","Cost",null,"Quantity","Cost",null,"Quantity","Cost"]
[{"$f":"'Unit Costs'!B5","v":"Parkstrip"},{"$f":"'Unit Costs'!C5","v":"S.F."},{"$f":"'Unit Costs'!D5","v":10},null,{"$f":"'Cross-Sections'!$D$27*200","v":1600},{"$f":"E6*$C6","v":16000},null,{"$f":"'Cross-Sections'!$D$24*200","v":2000},{"$f":"H6*$C6","v":20000},null,{"$f":"'Cross-Sections'!$D$21*200","v":1600},{"$f":"K6*$C6","v":16000},null,{"$f":"'Cross-Sections'!$D$18*200","v":1600},{"$f":"N6*$C6","v":16000},null,{"$f":"'Cross-Sections'!$D$15*200","v":2000},{"$f":"Q6*$C6","v":20000},null,{"$f":"'Cross-Sections'!$D$12*200","v":2000},{"$f":"T6*$C6","v":20000},null,{"$f":"'Cross-Sections'!$D$9*200","v":0},{"$f":"W6*$C6","v":0},null,{"$f":"'Cross-Sections'!$D$6*200","v":0},{"$f":"Z6*$C6","v":0},null,{"$f":"'Cross-Sections'!$D$3*200","v":1000},{"$f":"AC6*$C6","v":10000}]
[{"$f":"'Unit Costs'!B6","v":"Removal of Existing Asphalt"},{"$f":"'Unit Costs'!C6","v":"S.Y."},{"$f":"'Unit Costs'!D6","v":4},null,0,{"$f":"E7*$C7","v":0},null,0,{"$f":"H7*$C7","v":0},null,0,{"$f":"K7*$C7","v":0},null,0,{"$f":"N7*$C7","v":0},null,0,{"$f":"Q7*$C7","v":0},null,0,{"$f":"T7*$C7","v":0},null,0,{"$f":"W7*$C7","v":0},null,0,{"$f":"Z7*$C7","v":0},null,0,{"$f":"AC7*$C7","v":0}]
[{"$f":"'Unit Costs'!B7","v":"Clearing and Grubbing"},{"$f":"'Unit Costs'!C7","v":"Acre"},{"$f":"'Unit Costs'!D7","v":2000},null,{"$f":"'Cross-Sections'!$K$27*100/43560","v":0.15151515151515152},{"$f":"E8*$C8","v":303.03030303030306},null,{"$f":"'Cross-Sections'!$K$24*100/43560","v":0.16069788797061524},321.39577594123045,null,{"$f":"'Cross-Sections'!$K$21*100/43560","v":0.15610651974288339},312.21303948576679,null,{"$f":"'Cross-Sections'!$K$18*100/43560","v":0.22038567493112948},440.77134986225894,null,{"$f":"'Cross-Sections'!$K$15*100/43560","v":0.1928374655647383},385.67493112947659,null,{"$f":"'Cross-Sections'!$K$12*100/43560","v":0.21120293847566574},422.40587695133149,null,{"$f":"'Cross-Sections'!$K$9*100/43560","v":0.16069788797061524},321.39577594123045,null,{"$f":"'Cross-Sections'!$K$6*100/43560","v":0.21579430670339761},431.58861340679522,null,{"$f":"'Cross-Sections'!$K$3*100/43560","v":0.24334251606978879},486.68503213957757]
[{"$f":"'Unit Costs'!B8","v":"Roadway Excavation"},{"$f":"'Unit Costs'!C8","v":"C.Y."},{"$f":"'Unit Costs'!D8","v":10.5},null,{"$f":"'Cross-Sections'!$E$27*100*F39/27","v":18.518518518518519},{"$f":"E9*$C9","v":194.44444444444446},null,{"$f":"'Cross-Sections'!$E$24*100*I39/27","v":0},0,null,{"$f":"'Cross-Sections'!$E$21*100*L39/27","v":18.518518518518519},194.44444444444446,null,{"$f":"'Cross-Sections'!$E$18*100*O39/27","v":18.518518518518519},194.44444444444446,null,{"$f":"'Cross-Sections'!$E$15*100*R39/27","v":18.518518518518519},194.44444444444446,null,{"$f":"'Cross-Sections'!$E$12*100*U39/27","v":18.518518518518519},194.44444444444446,null,{"$f":"'Cross-Sections'!$E$9*100*X39/27","v":18.518518518518519},194.44444444444446,null,{"$f":"'Cross-Sections'!$E$6*100*AA39/27","v":18.518518518518519},194.44444444444446,null,{"$f":"'Cross-Sections'!$E$3*100*AD39/27","v":23.148148148148149},243.05555555555557]
[{"$f":"'Unit Costs'!B9","v":"HMA Concrete"},{"$f":"'Unit Costs'!C9","v":"Ton"},{"$f":"'Unit Costs'!D9","v":85},null,{"$f":"'Cross-Sections'!$E$27*100*(F36/12)*F35/2000","v":3.875},{"$f":"E10*$C10","v":329.375},null,{"$f":"'Cross-Sections'!$E$24*100*(I36/12)*I35/2000","v":0},0,null,{"$f":"'Cross-Sections'!$E$21*100*(L36/12)*L35/2000","v":5.1666666666666661},439.16666666666663,null,{"$f":"'Cross-Sections'!$E$18*100*(O36/12)*O35/2000","v":5.1666666666666661},439.16666666666663,null,{"$f":"'Cross-Sections'!$E$15*100*(R36/12)*R35/2000","v":5.1666666666666661},439.16666666666663,null,{"$f":"'Cross-Sections'!$E$12*100*(U36/12)*U35/2000","v":5.1666666666666661},439.16666666666663,null,{"$f":"'Cross-Sections'!$E$9*100*(X36/12)*X35/2000","v":5.1666666666666661},439.16666666666663,null,{"$f":"'Cross-Sections'!$E$6*100*(AA36/12)*AA35/2000","v":5.1666666666666661},439.16666666666663,null,{"$f":"'Cross-Sections'!$E$3*100*(AD36/12)*AD35/2000","v":6.458333333333333},548.95833333333326]
[{"$f":"'Unit Costs'!B10","v":"Untreated Base Course"},{"$f":"'Unit Costs'!C10","v":"C.Y."},{"$f":"'Unit Costs'!D10","v":15},null,{"$f":"'Cross-Sections'!$E$27*100*(F37/12)/27","v":4.9382716049382713},74.074074074074076,null,{"$f":"'Cross-Sections'!$E$24*100*(I37/12)/27","v":0},0,null,{"$f":"'Cross-Sections'!$E$21*100*(L37/12)/27","v":4.9382716049382713},74.074074074074076,null,{"$f":"'Cross-Sections'!$E$18*100*(O37/12)/27","v":4.9382716049382713},74.074074074074076,null,{"$f":"'Cross-Sections'!$E$15*100*(R37/12)/27","v":4.9382716049382713},74.074074074074076,null,{"$f":"'Cross-Sections'!$E$12*100*(U37/12)/27","v":4.9382716049382713},74.074074074074076,null,{"$f":"'Cross-Sections'!$E$9*100*(X37/12)/27","v":4.9382716049382713},74.074074074074076,null,{"$f":"'Cross-Sections'!$E$6*100*(AA37/12)/27","v":4.9382716049382713},74.074074074074076,null,{"$f":"'Cross-Sections'!$E$3*100*(AD37/12)/27","v":6.1728395061728394},92.592592592592595]
[{"$f":"'Unit Costs'!B11","v":"Granular Borrow"},{"$f":"'Unit Costs'!C11","v":"C.Y."},{"$f":"'Unit Costs'!D11","v":40},null,{"$f":"'Cross-Sections'!$E$27*100*F38/12/27","v":8.6419753086419764},345.67901234567904,null,{"$f":"'Cross-Sections'!$E$24*100*I38/12/27","v":0},0,null,{"$f":"'Cross-Sections'!$E$21*100*L38/12/27","v":8.6419753086419764},345.67901234567904,null,{"$f":"'Cross-Sections'!$E$18*100*O38/12/27","v":8.6419753086419764},345.67901234567904,null,{"$f":"'Cross-Sections'!$E$15*100*R38/12/27","v":8.6419753086419764},345.67901234567904,null,{"$f":"'Cross-Sections'!$E$12*100*U38/12/27","v":8.6419753086419764},345.67901234567904,null,{"$f":"'Cross-Sections'!$E$9*100*X38/12/27","v":8.6419753086419764},345.67901234567904,null,{"$f":"'Cross-Sections'!$E$6*100*AA38/12/27","v":8.6419753086419764},345.67901234567904,null,{"$f":"'Cross-Sections'!$E$3*100*AD38/12/27","v":10.80246913580247},432.09876543209879]
[{"$f":"'Unit Costs'!B12","v":"Curb and Gutter (2.5' width)"},{"$f":"'Unit Costs'!C12","v":"L.F."},{"$f":"'Unit Costs'!D12","v":22.5},null,200,4500,null,200,4500,null,200,4500,null,200,4500,null,200,4500,null,200,4500,null,200,4500,null,200,4500,null,200,4500]
[{"$f":"'Unit Costs'!B13","v":"Sidewalk (4' width)"},{"$f":"'Unit Costs'!C13","v":"L.F."},{"$f":"'Unit Costs'!D13","v":25},null,{"$f":"200*'Cross-Sections'!$C$27","v":1000},25000,null,{"$f":"200*'Cross-Sections'!$C$24","v":1000},25000,null,{"$f":"200*'Cross-Sections'!$C$21","v":1000},25000,null,{"$f":"200*'Cross-Sections'!$C$18","v":1000},25000,null,{"$f":"200*'Cross-Sections'!$C$15","v":1000},25000,null,{"$f":"200*'Cross-Sections'!$C$12","v":1000},25000,null,{"$f":"200*'Cross-Sections'!$C$9","v":1200},30000,null,{"$f":"200*'Cross-Sections'!$C$6","v":1200},30000,null,{"$f":"200*'Cross-Sections'!$C$3","v":1000},25000]
[{"$f":"'Unit Costs'!B14","v":"Drainage"},{"$f":"'Unit Costs'!C14","v":"L.F."},{"$f":"'Unit Costs'!D14","v":45},null,100,4500,null,100,4500,null,100,4500,null,100,4500,null,100,4500,null,100,4500,null,100,4500,null,100,4500,null,100,4500]
[{"$f":"'Unit Costs'!B15","v":"Right of Way"},{"$f":"'Unit Costs'!C15","v":"S.F."},{"$f":"'Unit Costs'!D15","v":15},null,{"$f":"100*'Cross-Sections'!$K$27","v":6600},99000,null,{"$f":"100*'Cross-Sections'!$K$24","v":7000},105000,null,{"$f":"100*'Cross-Sections'!$K$21","v":6800},{"$f":"K16*$C16","v":102000},null,{"$f":"100*'Cross-Sections'!$K$18","v":9600},144000,null,{"$f":"100*'Cross-Sections'!$K$15","v":8400},126000,null,{"$f":"100*'Cross-Sections'!$K$12","v":9200},138000,null,{"$f":"100*'Cross-Sections'!$K$9","v":7000},105000,null,{"$f":"100*'Cross-Sections'!$K$6","v":9400},141000,null,{"$f":"100*'Cross-Sections'!$K$3","v":10600},159000]
[{"$f":"IF('Unit Costs'!B16=\"\",\"\",'Unit Costs'!B16)","v":""},{"$f":"IF('Unit Costs'!C16=\"\",\"\",'Unit Costs'!C16)","v":""},{"$f":"IF('Unit Costs'!D16=\"\",\"\",'Unit Costs'!D16)","v":""},null,"-","-",null,"-","-",null,"-","-",null,"-","-",null,"-","-",null,"-","-",null,"-","-",null,"-","-",null,"-","-"]
[{"$f":"'Unit Costs'!B17","v":"Bridge/Culvert"},{"$f":"'Unit Costs'!C17","v":"S.F."},{"$f":"'Unit Costs'!D17","v":225},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,{"$f":"T18*$C18","v":0},null,0,{"$f":"W18*$C18","v":0},null,0,{"$f":"Z18*$C18","v":0},null,0,{"$f":"AC18*$C18","v":0}]
[{"$f":"'Unit Costs'!B18","v":"Traffic Signal"},{"$f":"'Unit Costs'!C18","v":"Each"},{"$f":"'Unit Costs'!D18","v":180000},null,0,{"$f":"E19*$C19","v":0},null,0,{"$f":"H19*$C19","v":0},null,0,{"$f":"K19*$C19","v":0},null,0,{"$f":"N19*$C19","v":0},null,0,{"$f":"Q19*$C19","v":0},null,0,{"$f":"T19*$C19","v":0},null,0,{"$f":"W19*$C19","v":0},null,0,{"$f":"Z19*$C19","v":0},null,0,{"$f":"AC19*$C19","v":0}]
["Subtotal",null,null,null,null,{"$f":"SUM(F6:F19)","v":150246.60283389449},null,null,{"$f":"SUM(I6:I19)","v":159321.39577594123},null,null,{"$f":"SUM(L6:L19)","v":153365.57723701664},null,null,{"$f":"SUM(O6:O19)","v":195494.13554739312},null,null,{"$f":"SUM(R6:R19)","v":181439.03912866034},null,null,{"$f":"SUM(U6:U19)","v":193475.77007448219},null,null,{"$f":"SUM(X6:X19)","v":145374.7599734721},null,null,{"$f":"SUM(AA6:AA19)","v":181484.95281093766},null,null,{"$f":"SUM(AD6:AD19)","v":204803.39027905316}]
[]
["Contingency",null,null,null,0.25,{"$f":"F$20*E22","v":37561.650708473622},null,null,{"$f":"I$20*$E22","v":39830.348943985307},null,null,{"$f":"L$20*$E22","v":38341.394309254159},null,null,{"$f":"O$20*$E22","v":48873.53388684828},null,null,{"$f":"R$20*$E22","v":45359.759782165085},null,null,{"$f":"U$20*$E22","v":48368.942518620548},null,null,{"$f":"X$20*$E22","v":36343.689993368025},null,null,{"$f":"AA$20*$E22","v":45371.238202734414},null,null,{"$f":"AD$20*$E22","v":51200.847569763289}]
[]
["Mobilization",null,null,null,0.1,{"$f":"F$20*E24","v":15024.66028338945},null,null,{"$f":"I$20*$E24","v":15932.139577594124},null,null,{"$f":"L$20*$E24","v":15336.557723701664},null,null,{"$f":"O$20*$E24","v":19549.413554739313},null,null,{"$f":"R$20*$E24","v":18143.903912866033},null,null,{"$f":"U$20*$E24","v":19347.577007448221},null,null,{"$f":"X$20*$E24","v":14537.47599734721},null,null,{"$f":"AA$20*$E24","v":18148.495281093765},null,null,{"$f":"AD$20*$E24","v":20480.339027905316}]
[]
["Preconstruction Engineering",null,null,null,0.08,{"$f":"F$20*E26","v":12019.728226711559},null,null,{"$f":"I$20*$E26","v":12745.711662075299},null,null,{"$f":"L$20*$E26","v":12269.246178961332},null,null,{"$f":"O$20*$E26","v":15639.53084379145},null,null,{"$f":"R$20*$E26","v":14515.123130292828},null,null,{"$f":"U$20*$E26","v":15478.061605958575},null,null,{"$f":"X$20*$E26","v":11629.980797877768},null,null,{"$f":"AA$20*$E26","v":14518.796224875012},null,null,{"$f":"AD$20*$E26","v":16384.271222324252}]
["Construction Engineering",null,null,null,0.08,{"$f":"F$20*E27","v":12019.728226711559},null,null,{"$f":"I$20*$E27","v":12745.711662075299},null,null,{"$f":"L$20*$E27","v":12269.246178961332},null,null,{"$f":"O$20*$E27","v":15639.53084379145},null,null,{"$f":"R$20*$E27","v":14515.123130292828},null,null,{"$f":"U$20*$E27","v":15478.061605958575},null,null,{"$f":"X$20*$E27","v":11629.980797877768},null,null,{"$f":"AA$20*$E27","v":14518.796224875012},null,null,{"$f":"AD$20*$E27","v":16384.271222324252}]
[]
["Total Project Cost",null,null,null,null,{"$f":"F20+F22+F24+F26+F27","v":226872.3702791807},null,null,{"$f":"I20+I22+I24+I26+I27","v":240575.30762167127},null,null,{"$f":"L20+L22+L24+L26+L27","v":231582.02162789513},null,null,{"$f":"O20+O22+O24+O26+O27","v":295196.14467656356},null,null,{"$f":"R20+R22+R24+R26+R27","v":273972.94908427709},null,null,{"$f":"U20+U22+U24+U26+U27","v":292148.41281246807},null,null,{"$f":"X20+X22+X24+X26+X27","v":219515.88755994287},null,null,{"$f":"AA20+AA22+AA24+AA26+AA27","v":274042.27874451585},null,null,{"$f":"AD20+AD22+AD24+AD26+AD27","v":309253.11932137021}]
[]
["Developers Responsibility",null,null,null,1,{"$f":"F$29*E31","v":226872.3702791807},null,{"$f":"$F$31/I29","v":0.9430409651017061},{"$f":"I$29*H31","v":226872.3702791807},null,{"$f":"$F$31/L29","v":0.9796631391521321},{"$f":"L$29*K31","v":226872.3702791807},null,{"$f":"$F$31/O29","v":0.76854787696416937},{"$f":"O$29*N31","v":226872.3702791807},null,{"$f":"$F$31/R29","v":0.82808310469144986},{"$f":"R$29*Q31","v":226872.3702791807},null,{"$f":"$F$31/U29","v":0.77656547264835396},{"$f":"U$29*T31","v":226872.3702791807},null,1,{"$f":"X$29*W31","v":219515.88755994287},null,{"$f":"$F$31/AA29","v":0.82787360884080696},{"$f":"AA$29*Z31","v":226872.3702791807},null,{"$f":"$F$31/AD29","v":0.73361384608515157},{"$f":"AD$29*AC31","v":226872.3702791807}]
["Layton City's Responsibility",null,null,null,0,{"$f":"F$29*E32","v":0},null,{"$f":"1-H31","v":5.6959034898293903E-2},{"$f":"I$29*H32","v":13702.937342490564},null,{"$f":"1-K31","v":2.0336860847867899E-2},{"$f":"L$29*K32","v":4709.6513487144375},null,{"$f":"1-N31","v":0.23145212303583063},{"$f":"O$29*N32","v":68323.774397382847},null,{"$f":"1-Q31","v":0.17191689530855014},{"$f":"R$29*Q32","v":47100.578805096404},null,{"$f":"1-T31","v":0.22343452735164604},{"$f":"U$29*T32","v":65276.042533287378},null,{"$f":"1-W31","v":0},{"$f":"X$29*W32","v":0},null,{"$f":"1-Z31","v":0.17212639115919304},{"$f":"AA$29*Z32","v":47169.908465335146},null,{"$f":"1-AC31","v":0.26638615391484843},{"$f":"AD$29*AC32","v":82380.749042189505}]
[]
["Overall Assumptions:"]
["HMA Pavement Density (pcf) =",null,null,null,null,{"$f":"Assumptions!$D$11","v":155},null,null,{"$f":"Assumptions!$D$10","v":155},null,null,{"$f":"Assumptions!$D$9","v":155},null,null,{"$f":"Assumptions!$D$8","v":155},null,null,{"$f":"Assumptions!$D$7","v":155},null,null,{"$f":"Assumptions!$D$6","v":155},null,null,{"$f":"Assumptions!$D$5","v":155},null,null,{"$f":"Assumptions!$D$4","v":155},null,null,{"$f":"Assumptions!$D$3","v":155}]
["HMA Thickness (in) =",null,null,null,null,{"$f":"Assumptions!$E$11","v":3},null,null,{"$f":"Assumptions!$E$10","v":3},null,null,{"$f":"Assumptions!$E$9","v":4},null,null,{"$f":"Assumptions!$E$8","v":4},null,null,{"$f":"Assumptions!$E$7","v":4},null,null,{"$f":"Assumptions!$E$6","v":4},null,null,{"$f":"Assumptions!$E$5","v":4},null,null,{"$f":"Assumptions!$E$4","v":4},null,null,{"$f":"Assumptions!$E$3","v":4}]
["Untreated Base Course Thickness (in) =",null,null,null,null,{"$f":"Assumptions!$F$11","v":8},null,null,{"$f":"Assumptions!$F$10","v":8},null,null,{"$f":"Assumptions!$F$9","v":8},null,null,{"$f":"Assumptions!$F$8","v":8},null,null,{"$f":"Assumptions!$F$7","v":8},null,null,{"$f":"Assumptions!$F$6","v":8},null,null,{"$f":"Assumptions!$F$5","v":8},null,null,{"$f":"Assumptions!$F$4","v":8},null,null,{"$f":"Assumptions!$F$3","v":8}]
["Granual Borrow Thickness (in) =",null,null,null,null,{"$f":"Assumptions!$G$11","v":14},null,null,{"$f":"Assumptions!$G$10","v":14},null,null,{"$f":"Assumptions!$G$9","v":14},null,null,{"$f":"Assumptions!$G$8","v":14},null,null,{"$f":"Assumptions!$G$7","v":14},null,null,{"$f":"Assumptions!$G$6","v":14},null,null,{"$f":"Assumptions!$G$5","v":14},null,null,{"$f":"Assumptions!$G$4","v":14},null,null,{"$f":"Assumptions!$G$3","v":14}]
["Roadway Excavation Depth (ft) =",null,null,null,null,{"$f":"Assumptions!$H$11","v":2.5},null,null,{"$f":"Assumptions!$H$10","v":2.5},null,null,{"$f":"Assumptions!$H$9","v":2.5},null,null,{"$f":"Assumptions!$H$8","v":2.5},null,null,{"$f":"Assumptions!$H$7","v":2.5},null,null,{"$f":"Assumptions!$H$6","v":2.5},null,null,{"$f":"Assumptions!$H$5","v":2.5},null,null,{"$f":"Assumptions!$H$4","v":2.5},null,null,{"$f":"Assumptions!$H$3","v":2.5}]
["Number of Sidewalks (No.) =",null,null,null,null,{"$f":"Assumptions!$I$11","v":2},null,null,{"$f":"Assumptions!$I$10","v":2},null,null,{"$f":"Assumptions!$I$9","v":2},null,null,{"$f":"Assumptions!$I$8","v":2},null,null,{"$f":"Assumptions!$I$7","v":2},null,null,{"$f":"Assumptions!$I$6","v":2},null,null,{"$f":"Assumptions!$I$5","v":2},null,null,{"$f":"Assumptions!$I$4","v":2},null,null,{"$f":"Assumptions!$I$3","v":2}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Template","index":7,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[63,0,63,2],[29,0,29,2],[31,0,31,3],[33,0,34,3],[55,0,55,2],[57,0,57,2],[58,0,58,2],[4,0,4,4],[5,0,5,4],[59,0,59,2],[61,0,61,2],[62,0,62,2],[28,0,28,2],[6,0,6,4],[7,6,7,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[13,6,13,8],[14,6,14,8],[15,6,15,8],[22,0,22,3],[24,0,24,2],[26,0,26,2],[0,0,0,4],[1,0,1,4],[2,0,2,1],[3,0,3,1],[2,6,3,7]]}
[{"$f":"'Unit Costs'!B1","v":"Provo"}]
["Transportation Master Plan "]
["Project No.",null,{"$f":"'Unit Costs'!F1","v":1},null,null,null,"Back to Projects Tab"]
["Improvement Type:",null,{"$f":"VLOOKUP(A5,Projects!$C$3:$D$103,2,FALSE)","v":"New"}]
[{"$f":"VLOOKUP(C3,Projects!$B$3:$C$102,2,FALSE)","v":"asdfafs"}]
["Arterial"]
["Costs"]
["Item","Unit","Unit Cost","Quantity","Cost",null,"Length of Segment",null,null,100]
[{"$f":"IF('Unit Costs'!B5=\"\",\"\",'Unit Costs'!B5)","v":"Parkstrip"},{"$f":"IF('Unit Costs'!C5=\"\",\"\",'Unit Costs'!C5)","v":"S.F."},{"$f":"IF('Unit Costs'!D5=\"\",\"\",'Unit Costs'!D5)","v":10},{"$f":"IF(J12=0,\"\",IF(C9=\"\",\"\",VLOOKUP($A$6,Assumptions!C3:N11,8,FALSE)*2*J8))","v":1000},{"$f":"IF(C9=\"\",\"\",D9*C9)","v":10000}]
[{"$f":"IF('Unit Costs'!B6=\"\",\"\",'Unit Costs'!B6)","v":"Removal of Existing Asphalt"},{"$f":"IF('Unit Costs'!C6=\"\",\"\",'Unit Costs'!C6)","v":"S.Y."},{"$f":"IF('Unit Costs'!D6=\"\",\"\",'Unit Costs'!D6)","v":4},{"$f":"IF(J15=0,0,IF(C10=\"\",\"\",IF(C10>0,((J15*J8)/9),\"\")))","v":0},{"$f":"IF(C10=\"\",\"\",D10*C10)","v":0},null,"Total ROW Needed",null,null,{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,12,FALSE)","v":106}]
[{"$f":"IF('Unit Costs'!B7=\"\",\"\",'Unit Costs'!B7)","v":"Clearing and Grubbing"},{"$f":"IF('Unit Costs'!C7=\"\",\"\",'Unit Costs'!C7)","v":"Acre"},{"$f":"IF('Unit Costs'!D7=\"\",\"\",'Unit Costs'!D7)","v":2000},{"$f":"IF(C11=\"\",\"\",(J8*J12)/43560)","v":0.24334251606978879},486.68503213957757,null,{"$f":"\"Existing ROW (min \" & '[1]Cross-Sections'!K18 & \"')\"","v":"Existing ROW (min 96')"},null,null,0]
[{"$f":"IF('Unit Costs'!B8=\"\",\"\",'Unit Costs'!B8)","v":"Roadway Excavation"},{"$f":"IF('Unit Costs'!C8=\"\",\"\",'Unit Costs'!C8)","v":"C.Y."},{"$f":"IF('Unit Costs'!D8=\"\",\"\",'Unit Costs'!D8)","v":10.5},{"$f":"IF(C12=\"\",\"\",(J8*J16*B42)/27)","v":750},7875,null,"ROW Needed",null,null,{"$f":"J10-J11","v":106}]
[{"$f":"IF('Unit Costs'!B9=\"\",\"\",'Unit Costs'!B9)","v":"HMA Concrete"},{"$f":"IF('Unit Costs'!C9=\"\",\"\",'Unit Costs'!C9)","v":"Ton"},{"$f":"IF('Unit Costs'!D9=\"\",\"\",'Unit Costs'!D9)","v":85},{"$f":"IF(C13=\"\",\"\",J8*J16*(B39/12)*B38/2000)","v":209.25},17786.25]
[{"$f":"IF('Unit Costs'!B10=\"\",\"\",'Unit Costs'!B10)","v":"Untreated Base Course"},{"$f":"IF('Unit Costs'!C10=\"\",\"\",'Unit Costs'!C10)","v":"C.Y."},{"$f":"IF('Unit Costs'!D10=\"\",\"\",'Unit Costs'!D10)","v":15},{"$f":"IF(C14=\"\",\"\",(J8*J16*(B40/12))/27)","v":200},3000,null,"Total Pavement Width",null,null,{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,9,FALSE)","v":81}]
[{"$f":"IF('Unit Costs'!B11=\"\",\"\",'Unit Costs'!B11)","v":"Granular Borrow"},{"$f":"IF('Unit Costs'!C11=\"\",\"\",'Unit Costs'!C11)","v":"C.Y."},{"$f":"IF('Unit Costs'!D11=\"\",\"\",'Unit Costs'!D11)","v":40},{"$f":"IF(C15=\"\",\"\",J8*J16*(B41/12)/27)","v":350},14000,null,{"$f":"\"Existing ROW (min \" & '[1]Cross-Sections'!E19 & \"')\"","v":"Existing ROW (min 42')"},null,null,0]
[{"$f":"IF('Unit Costs'!B12=\"\",\"\",'Unit Costs'!B12)","v":"Curb and Gutter (2.5' width)"},{"$f":"IF('Unit Costs'!C12=\"\",\"\",'Unit Costs'!C12)","v":"L.F."},{"$f":"IF('Unit Costs'!D12=\"\",\"\",'Unit Costs'!D12)","v":22.5},{"$f":"IF(C16=\"\",\"\",2*J8)","v":200},4500,null,"Pavement Width Needed",null,null,{"$f":"J14-J15","v":81}]
[{"$f":"IF('Unit Costs'!B13=\"\",\"\",'Unit Costs'!B13)","v":"Sidewalk (4' width)"},{"$f":"IF('Unit Costs'!C13=\"\",\"\",'Unit Costs'!C13)","v":"L.F."},{"$f":"IF('Unit Costs'!D12=\"\",\"\",IF(A6='Cross-Sections'!A9,30,25))","v":25},{"$f":"IF(C17=\"\",\"\",(B43*J8))","v":200},5000]
[{"$f":"IF('Unit Costs'!B14=\"\",\"\",'Unit Costs'!B14)","v":"Drainage"},{"$f":"IF('Unit Costs'!C14=\"\",\"\",'Unit Costs'!C14)","v":"L.F."},{"$f":"IF('Unit Costs'!D14=\"\",\"\",'Unit Costs'!D14)","v":45},{"$f":"IF(C18=\"\",\"\",2*J8)","v":200},9000]
[{"$f":"IF('Unit Costs'!B15=\"\",\"\",'Unit Costs'!B15)","v":"Right of Way"},{"$f":"IF('Unit Costs'!C15=\"\",\"\",'Unit Costs'!C15)","v":"S.F."},{"$f":"IF('Unit Costs'!D15=\"\",\"\",'Unit Costs'!D15)","v":15},{"$f":"IF(C19=\"\",\"\",(J8)*J12)","v":10600},159000]
[{"$f":"IF('Unit Costs'!B16=\"\",\"\",'Unit Costs'!B16)","v":""},{"$f":"IF('Unit Costs'!C16=\"\",\"\",'Unit Costs'!C16)","v":""},{"$f":"IF('Unit Costs'!D16=\"\",\"\",'Unit Costs'!D16)","v":""},{"$f":"IF(C20=\"\",\"\",J8*8/3*155/2000)","v":""},""]
[{"$f":"IF('Unit Costs'!B17=\"\",\"\",'Unit Costs'!B17)","v":"Bridge/Culvert"},{"$f":"IF('Unit Costs'!C17=\"\",\"\",'Unit Costs'!C17)","v":"S.F."},{"$f":"IF('Unit Costs'!D17=\"\",\"\",'Unit Costs'!D17)","v":225},{"$f":"IF(C21=\"\",\"\",0)","v":0},0]
[{"$f":"IF('Unit Costs'!B18=\"\",\"\",'Unit Costs'!B18)","v":"Traffic Signal"},{"$f":"IF('Unit Costs'!C18=\"\",\"\",'Unit Costs'!C18)","v":"Each"},{"$f":"IF('Unit Costs'!D18=\"\",\"\",'Unit Costs'!D18)","v":180000},{"$f":"IF(C22=\"\",\"\",0)","v":0},0]
["Subtotal",null,null,null,{"$f":"(SUM(E9:E22))","v":230647.93503213959}]
[]
["Contingency",null,null,{"$f":"'Unit Costs'!C20","v":0.25},{"$f":"D25*E23","v":57661.983758034898}]
[]
["Mobilization",null,null,{"$f":"'Unit Costs'!C22","v":0.1},{"$f":"D27*E23","v":23064.793503213961}]
[]
["Preconstruction Engineering",null,null,{"$f":"'Unit Costs'!C24","v":0.08},{"$f":"D29*E23","v":18451.834802571168}]
["Construction Engineering",null,null,{"$f":"'Unit Costs'!C25","v":0.08},{"$f":"D30*E23","v":18451.834802571168}]
[]
["Total Project Costs",null,null,null,{"$f":"ROUNDUP(SUM(E23,E25,E27,E29:E30),-2)","v":348300}]
[]
[{"$f":"'Unit Costs'!B1&\"'s Responsibility Via Impact Fee's\"","v":"Provo's Responsibility Via Impact Fee's"},null,null,null,{"$f":"IF(VLOOKUP($A$5,Projects!$C$3:$E$103,3,FALSE)=DROPDOWNS!$D$5,0,IF(VLOOKUP($A$5,Projects!$C$3:$E$103,3,FALSE)=DROPDOWNS!$D$4,0.07,IF(VLOOKUP($A$5,Projects!$C$3:$E$103,2,FALSE)=DROPDOWNS!$B$7,1,IF(VLOOKUP($A$5,Projects!$C$3:$E$103,2,FALSE)=DROPDOWNS!$B$4,1,VLOOKUP($A$6,Assumptions!$C$3:$O$11,13,FALSE)))))","v":0.26638615391484843}]
[null,null,null,null,{"$f":"ROUND(E34*E32,-4)","v":90000}]
[]
[{"$f":"'Cross-Section Comparison'!A34:C34","v":"Overall Assumptions:"}]
[{"$f":"'Cross-Section Comparison'!A35:C35","v":"HMA Pavement Density (pcf) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,2,FALSE)","v":155}]
[{"$f":"'Cross-Section Comparison'!A36:C36","v":"HMA Thickness (in) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,3,FALSE)","v":4}]
[{"$f":"'Cross-Section Comparison'!A37:C37","v":"Untreated Base Course Thickness (in) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,4,FALSE)","v":8}]
[{"$f":"'Cross-Section Comparison'!A38:C38","v":"Granual Borrow Thickness (in) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,5,FALSE)","v":14}]
[{"$f":"'Cross-Section Comparison'!A39:C39","v":"Roadway Excavation Depth (ft) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,6,FALSE)","v":2.5}]
[{"$f":"'Cross-Section Comparison'!A40:C40","v":"Number of Sidewalks (No.) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,7,FALSE)","v":2}]
[{"$f":"IF('Unit Costs'!B34=\"\",\"\",'Unit Costs'!B34)","v":""},{"$f":"IF('Unit Costs'!C34=\"\",\"\",'Unit Costs'!C34)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B35=\"\",\"\",'[1]Unit Costs'!B35)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B36=\"\",\"\",'[1]Unit Costs'!B36)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B37=\"\",\"\",'[1]Unit Costs'!B37)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B38=\"\",\"\",'[1]Unit Costs'!B38)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B39=\"\",\"\",'[1]Unit Costs'!B39)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B40=\"\",\"\",'[1]Unit Costs'!B40)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B42=\"\",\"\",'[1]Unit Costs'!B42)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B43=\"\",\"\",'[1]Unit Costs'!B43)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B44=\"\",\"\",'[1]Unit Costs'!B44)","v":""}]

{"sheet":"1","index":8,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[11,6,11,8],[0,0,0,4],[1,0,1,4],[2,0,2,1],[2,6,3,7],[3,0,3,1],[4,0,4,4],[5,0,5,4],[6,0,6,4],[7,6,7,8],[9,6,9,8],[10,6,10,8],[57,0,57,2],[13,6,13,8],[14,6,14,8],[15,6,15,8],[22,0,22,3],[24,0,24,2],[26,0,26,2],[28,0,28,2],[29,0,29,2],[31,0,31,3],[33,0,34,3],[55,0,55,2],[58,0,58,2],[59,0,59,2],[61,0,61,2],[62,0,62,2],[63,0,63,2]]}
[{"$f":"'Unit Costs'!B1","v":"Provo"}]
["Transportation Master Plan "]
["Project No.",null,1,null,null,null,"Back to Projects Tab"]
["Improvement Type:",null,{"$f":"VLOOKUP(A5,Projects!$C$3:$D$103,2,FALSE)","v":"New"}]
[{"$f":"VLOOKUP(C3,Projects!$B$3:$C$102,2,FALSE)","v":"asdfafs"}]
["Arterial"]
["Costs"]
["Item","Unit","Unit Cost","Quantity","Cost",null,"Length of Segment",null,null,50]
[{"$f":"IF('Unit Costs'!B5=\"\",\"\",'Unit Costs'!B5)","v":"Parkstrip"},{"$f":"IF('Unit Costs'!C5=\"\",\"\",'Unit Costs'!C5)","v":"S.F."},{"$f":"IF('Unit Costs'!D5=\"\",\"\",'Unit Costs'!D5)","v":10},{"$f":"IF(J12=0,\"\",IF(C9=\"\",\"\",VLOOKUP($A$6,Assumptions!C3:N11,8,FALSE)*2*J8))","v":500},{"$f":"IF(C9=\"\",\"\",D9*C9)","v":5000}]
[{"$f":"IF('Unit Costs'!B6=\"\",\"\",'Unit Costs'!B6)","v":"Removal of Existing Asphalt"},{"$f":"IF('Unit Costs'!C6=\"\",\"\",'Unit Costs'!C6)","v":"S.Y."},{"$f":"IF('Unit Costs'!D6=\"\",\"\",'Unit Costs'!D6)","v":4},{"$f":"IF(J15=0,0,IF(C10=\"\",\"\",IF(C10>0,((J15*J8)/9),\"\")))","v":0},{"$f":"IF(C10=\"\",\"\",D10*C10)","v":0},null,"Total ROW Needed",null,null,{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,12,FALSE)","v":106}]
[{"$f":"IF('Unit Costs'!B7=\"\",\"\",'Unit Costs'!B7)","v":"Clearing and Grubbing"},{"$f":"IF('Unit Costs'!C7=\"\",\"\",'Unit Costs'!C7)","v":"Acre"},{"$f":"IF('Unit Costs'!D7=\"\",\"\",'Unit Costs'!D7)","v":2000},{"$f":"IF(C11=\"\",\"\",(J8*J12)/43560)","v":0.1216712580348944},243.34251606978879,null,{"$f":"\"Existing ROW (min \" & '[1]Cross-Sections'!K18 & \"')\"","v":"Existing ROW (min 96')"},null,null,0]
[{"$f":"IF('Unit Costs'!B8=\"\",\"\",'Unit Costs'!B8)","v":"Roadway Excavation"},{"$f":"IF('Unit Costs'!C8=\"\",\"\",'Unit Costs'!C8)","v":"C.Y."},{"$f":"IF('Unit Costs'!D8=\"\",\"\",'Unit Costs'!D8)","v":10.5},{"$f":"IF(C12=\"\",\"\",(J8*J16*B42)/27)","v":375},3937.5,null,"ROW Needed",null,null,{"$f":"J10-J11","v":106}]
[{"$f":"IF('Unit Costs'!B9=\"\",\"\",'Unit Costs'!B9)","v":"HMA Concrete"},{"$f":"IF('Unit Costs'!C9=\"\",\"\",'Unit Costs'!C9)","v":"Ton"},{"$f":"IF('Unit Costs'!D9=\"\",\"\",'Unit Costs'!D9)","v":85},{"$f":"IF(C13=\"\",\"\",J8*J16*(B39/12)*B38/2000)","v":104.625},8893.125]
[{"$f":"IF('Unit Costs'!B10=\"\",\"\",'Unit Costs'!B10)","v":"Untreated Base Course"},{"$f":"IF('Unit Costs'!C10=\"\",\"\",'Unit Costs'!C10)","v":"C.Y."},{"$f":"IF('Unit Costs'!D10=\"\",\"\",'Unit Costs'!D10)","v":15},{"$f":"IF(C14=\"\",\"\",(J8*J16*(B40/12))/27)","v":100},1500,null,"Total Pavement Width",null,null,{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,9,FALSE)","v":81}]
[{"$f":"IF('Unit Costs'!B11=\"\",\"\",'Unit Costs'!B11)","v":"Granular Borrow"},{"$f":"IF('Unit Costs'!C11=\"\",\"\",'Unit Costs'!C11)","v":"C.Y."},{"$f":"IF('Unit Costs'!D11=\"\",\"\",'Unit Costs'!D11)","v":40},{"$f":"IF(C15=\"\",\"\",J8*J16*(B41/12)/27)","v":175},7000,null,{"$f":"\"Existing ROW (min \" & '[1]Cross-Sections'!E19 & \"')\"","v":"Existing ROW (min 42')"},null,null,0]
[{"$f":"IF('Unit Costs'!B12=\"\",\"\",'Unit Costs'!B12)","v":"Curb and Gutter (2.5' width)"},{"$f":"IF('Unit Costs'!C12=\"\",\"\",'Unit Costs'!C12)","v":"L.F."},{"$f":"IF('Unit Costs'!D12=\"\",\"\",'Unit Costs'!D12)","v":22.5},{"$f":"IF(C16=\"\",\"\",2*J8)","v":100},2250,null,"Pavement Width Needed",null,null,{"$f":"J14-J15","v":81}]
[{"$f":"IF('Unit Costs'!B13=\"\",\"\",'Unit Costs'!B13)","v":"Sidewalk (4' width)"},{"$f":"IF('Unit Costs'!C13=\"\",\"\",'Unit Costs'!C13)","v":"L.F."},{"$f":"IF('Unit Costs'!D12=\"\",\"\",IF(A6='Cross-Sections'!A9,30,25))","v":25},{"$f":"IF(C17=\"\",\"\",(B43*J8))","v":100},2500]
[{"$f":"IF('Unit Costs'!B14=\"\",\"\",'Unit Costs'!B14)","v":"Drainage"},{"$f":"IF('Unit Costs'!C14=\"\",\"\",'Unit Costs'!C14)","v":"L.F."},{"$f":"IF('Unit Costs'!D14=\"\",\"\",'Unit Costs'!D14)","v":45},{"$f":"IF(C18=\"\",\"\",2*J8)","v":100},4500]
[{"$f":"IF('Unit Costs'!B15=\"\",\"\",'Unit Costs'!B15)","v":"Right of Way"},{"$f":"IF('Unit Costs'!C15=\"\",\"\",'Unit Costs'!C15)","v":"S.F."},{"$f":"IF('Unit Costs'!D15=\"\",\"\",'Unit Costs'!D15)","v":15},{"$f":"IF(C19=\"\",\"\",(J8)*J12)","v":5300},79500]
[{"$f":"IF('Unit Costs'!B16=\"\",\"\",'Unit Costs'!B16)","v":""},{"$f":"IF('Unit Costs'!C16=\"\",\"\",'Unit Costs'!C16)","v":""},{"$f":"IF('Unit Costs'!D16=\"\",\"\",'Unit Costs'!D16)","v":""},{"$f":"IF(C20=\"\",\"\",J8*8/3*155/2000)","v":""},""]
[{"$f":"IF('Unit Costs'!B17=\"\",\"\",'Unit Costs'!B17)","v":"Bridge/Culvert"},{"$f":"IF('Unit Costs'!C17=\"\",\"\",'Unit Costs'!C17)","v":"S.F."},{"$f":"IF('Unit Costs'!D17=\"\",\"\",'Unit Costs'!D17)","v":225},{"$f":"IF(C21=\"\",\"\",0)","v":0},0]
[{"$f":"IF('Unit Costs'!B18=\"\",\"\",'Unit Costs'!B18)","v":"Traffic Signal"},{"$f":"IF('Unit Costs'!C18=\"\",\"\",'Unit Costs'!C18)","v":"Each"},{"$f":"IF('Unit Costs'!D18=\"\",\"\",'Unit Costs'!D18)","v":180000},{"$f":"IF(C22=\"\",\"\",0)","v":0},0]
["Subtotal",null,null,null,{"$f":"(SUM(E9:E22))","v":115323.9675160698}]
[]
["Contingency",null,null,{"$f":"'Unit Costs'!C20","v":0.25},{"$f":"D25*E23","v":28830.991879017449}]
[]
["Mobilization",null,null,{"$f":"'Unit Costs'!C22","v":0.1},{"$f":"D27*E23","v":11532.396751606981}]
[]
["Preconstruction Engineering",null,null,{"$f":"'Unit Costs'!C24","v":0.08},{"$f":"D29*E23","v":9225.9174012855838}]
["Construction Engineering",null,null,{"$f":"'Unit Costs'!C25","v":0.08},{"$f":"D30*E23","v":9225.9174012855838}]
[]
["Total Project Costs",null,null,null,{"$f":"ROUNDUP(SUM(E23,E25,E27,E29:E30),-2)","v":174200}]
[]
[{"$f":"'Unit Costs'!B1&\"'s Responsibility Via Impact Fee's\"","v":"Provo's Responsibility Via Impact Fee's"},null,null,null,{"$f":"IF(VLOOKUP($A$5,Projects!$C$3:$E$103,3,FALSE)=DROPDOWNS!$D$5,0,IF(VLOOKUP($A$5,Projects!$C$3:$E$103,3,FALSE)=DROPDOWNS!$D$4,0.07,IF(VLOOKUP($A$5,Projects!$C$3:$E$103,2,FALSE)=DROPDOWNS!$B$7,1,IF(VLOOKUP($A$5,Projects!$C$3:$E$103,2,FALSE)=DROPDOWNS!$B$4,1,VLOOKUP($A$6,Assumptions!$C$3:$O$11,13,FALSE)))))","v":0.26638615391484843}]
[null,null,null,null,{"$f":"ROUND(E34*E32,-4)","v":50000}]
[]
[{"$f":"'Cross-Section Comparison'!A34:C34","v":"Overall Assumptions:"}]
[{"$f":"'Cross-Section Comparison'!A35:C35","v":"HMA Pavement Density (pcf) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,2,FALSE)","v":155}]
[{"$f":"'Cross-Section Comparison'!A36:C36","v":"HMA Thickness (in) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,3,FALSE)","v":4}]
[{"$f":"'Cross-Section Comparison'!A37:C37","v":"Untreated Base Course Thickness (in) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,4,FALSE)","v":8}]
[{"$f":"'Cross-Section Comparison'!A38:C38","v":"Granual Borrow Thickness (in) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,5,FALSE)","v":14}]
[{"$f":"'Cross-Section Comparison'!A39:C39","v":"Roadway Excavation Depth (ft) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,6,FALSE)","v":2.5}]
[{"$f":"'Cross-Section Comparison'!A40:C40","v":"Number of Sidewalks (No.) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,7,FALSE)","v":2}]
[{"$f":"IF('Unit Costs'!B34=\"\",\"\",'Unit Costs'!B34)","v":""},{"$f":"IF('Unit Costs'!C34=\"\",\"\",'Unit Costs'!C34)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B35=\"\",\"\",'[1]Unit Costs'!B35)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B36=\"\",\"\",'[1]Unit Costs'!B36)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B37=\"\",\"\",'[1]Unit Costs'!B37)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B38=\"\",\"\",'[1]Unit Costs'!B38)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B39=\"\",\"\",'[1]Unit Costs'!B39)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B40=\"\",\"\",'[1]Unit Costs'!B40)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B42=\"\",\"\",'[1]Unit Costs'!B42)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B43=\"\",\"\",'[1]Unit Costs'!B43)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B44=\"\",\"\",'[1]Unit Costs'!B44)","v":""}]

{"sheet":"2","index":9,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[58,0,58,2],[59,0,59,2],[61,0,61,2],[62,0,62,2],[63,0,63,2],[28,0,28,2],[29,0,29,2],[31,0,31,3],[33,0,34,3],[55,0,55,2],[57,0,57,2],[13,6,13,8],[14,6,14,8],[15,6,15,8],[22,0,22,3],[24,0,24,2],[26,0,26,2],[5,0,5,4],[6,0,6,4],[7,6,7,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[0,0,0,4],[1,0,1,4],[2,0,2,1],[2,6,3,7],[3,0,3,1],[4,0,4,4]]}
[{"$f":"'Unit Costs'!B1","v":"Provo"}]
["Transportation Master Plan "]
["Project No.",null,2,null,null,null,"Back to Projects Tab"]
["Improvement Type:",null,{"$f":"VLOOKUP(A5,Projects!$C$3:$D$103,2,FALSE)","v":"New"}]
[{"$f":"VLOOKUP(C3,Projects!$B$3:$C$102,2,FALSE)","v":"new streets"}]
["Arterial"]
["Costs"]
["Item","Unit","Unit Cost","Quantity","Cost",null,"Length of Segment",null,null,100]
[{"$f":"IF('Unit Costs'!B5=\"\",\"\",'Unit Costs'!B5)","v":"Parkstrip"},{"$f":"IF('Unit Costs'!C5=\"\",\"\",'Unit Costs'!C5)","v":"S.F."},{"$f":"IF('Unit Costs'!D5=\"\",\"\",'Unit Costs'!D5)","v":10},{"$f":"IF(J12=0,\"\",IF(C9=\"\",\"\",VLOOKUP($A$6,Assumptions!C3:N11,8,FALSE)*2*J8))","v":1000},{"$f":"IF(C9=\"\",\"\",D9*C9)","v":10000}]
[{"$f":"IF('Unit Costs'!B6=\"\",\"\",'Unit Costs'!B6)","v":"Removal of Existing Asphalt"},{"$f":"IF('Unit Costs'!C6=\"\",\"\",'Unit Costs'!C6)","v":"S.Y."},{"$f":"IF('Unit Costs'!D6=\"\",\"\",'Unit Costs'!D6)","v":4},{"$f":"IF(J15=0,0,IF(C10=\"\",\"\",IF(C10>0,((J15*J8)/9),\"\")))","v":0},{"$f":"IF(C10=\"\",\"\",D10*C10)","v":0},null,"Total ROW Needed",null,null,{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,12,FALSE)","v":106}]
[{"$f":"IF('Unit Costs'!B7=\"\",\"\",'Unit Costs'!B7)","v":"Clearing and Grubbing"},{"$f":"IF('Unit Costs'!C7=\"\",\"\",'Unit Costs'!C7)","v":"Acre"},{"$f":"IF('Unit Costs'!D7=\"\",\"\",'Unit Costs'!D7)","v":2000},{"$f":"IF(C11=\"\",\"\",(J8*J12)/43560)","v":0.24334251606978879},486.68503213957757,null,{"$f":"\"Existing ROW (min \" & '[1]Cross-Sections'!K18 & \"')\"","v":"Existing ROW (min 96')"},null,null,0]
[{"$f":"IF('Unit Costs'!B8=\"\",\"\",'Unit Costs'!B8)","v":"Roadway Excavation"},{"$f":"IF('Unit Costs'!C8=\"\",\"\",'Unit Costs'!C8)","v":"C.Y."},{"$f":"IF('Unit Costs'!D8=\"\",\"\",'Unit Costs'!D8)","v":10.5},{"$f":"IF(C12=\"\",\"\",(J8*J16*B42)/27)","v":750},7875,null,"ROW Needed",null,null,{"$f":"J10-J11","v":106}]
[{"$f":"IF('Unit Costs'!B9=\"\",\"\",'Unit Costs'!B9)","v":"HMA Concrete"},{"$f":"IF('Unit Costs'!C9=\"\",\"\",'Unit Costs'!C9)","v":"Ton"},{"$f":"IF('Unit Costs'!D9=\"\",\"\",'Unit Costs'!D9)","v":85},{"$f":"IF(C13=\"\",\"\",J8*J16*(B39/12)*B38/2000)","v":209.25},17786.25]
[{"$f":"IF('Unit Costs'!B10=\"\",\"\",'Unit Costs'!B10)","v":"Untreated Base Course"},{"$f":"IF('Unit Costs'!C10=\"\",\"\",'Unit Costs'!C10)","v":"C.Y."},{"$f":"IF('Unit Costs'!D10=\"\",\"\",'Unit Costs'!D10)","v":15},{"$f":"IF(C14=\"\",\"\",(J8*J16*(B40/12))/27)","v":200},3000,null,"Total Pavement Width",null,null,{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,9,FALSE)","v":81}]
[{"$f":"IF('Unit Costs'!B11=\"\",\"\",'Unit Costs'!B11)","v":"Granular Borrow"},{"$f":"IF('Unit Costs'!C11=\"\",\"\",'Unit Costs'!C11)","v":"C.Y."},{"$f":"IF('Unit Costs'!D11=\"\",\"\",'Unit Costs'!D11)","v":40},{"$f":"IF(C15=\"\",\"\",J8*J16*(B41/12)/27)","v":350},14000,null,{"$f":"\"Existing ROW (min \" & '[1]Cross-Sections'!E19 & \"')\"","v":"Existing ROW (min 42')"},null,null,0]
[{"$f":"IF('Unit Costs'!B12=\"\",\"\",'Unit Costs'!B12)","v":"Curb and Gutter (2.5' width)"},{"$f":"IF('Unit Costs'!C12=\"\",\"\",'Unit Costs'!C12)","v":"L.F."},{"$f":"IF('Unit Costs'!D12=\"\",\"\",'Unit Costs'!D12)","v":22.5},{"$f":"IF(C16=\"\",\"\",2*J8)","v":200},4500,null,"Pavement Width Needed",null,null,{"$f":"J14-J15","v":81}]
[{"$f":"IF('Unit Costs'!B13=\"\",\"\",'Unit Costs'!B13)","v":"Sidewalk (4' width)"},{"$f":"IF('Unit Costs'!C13=\"\",\"\",'Unit Costs'!C13)","v":"L.F."},{"$f":"IF('Unit Costs'!D12=\"\",\"\",IF(A6='Cross-Sections'!A9,30,25))","v":25},{"$f":"IF(C17=\"\",\"\",(B43*J8))","v":200},5000]
[{"$f":"IF('Unit Costs'!B14=\"\",\"\",'Unit Costs'!B14)","v":"Drainage"},{"$f":"IF('Unit Costs'!C14=\"\",\"\",'Unit Costs'!C14)","v":"L.F."},{"$f":"IF('Unit Costs'!D14=\"\",\"\",'Unit Costs'!D14)","v":45},{"$f":"IF(C18=\"\",\"\",2*J8)","v":200},9000]
[{"$f":"IF('Unit Costs'!B15=\"\",\"\",'Unit Costs'!B15)","v":"Right of Way"},{"$f":"IF('Unit Costs'!C15=\"\",\"\",'Unit Costs'!C15)","v":"S.F."},{"$f":"IF('Unit Costs'!D15=\"\",\"\",'Unit Costs'!D15)","v":15},{"$f":"IF(C19=\"\",\"\",(J8)*J12)","v":10600},159000]
[{"$f":"IF('Unit Costs'!B16=\"\",\"\",'Unit Costs'!B16)","v":""},{"$f":"IF('Unit Costs'!C16=\"\",\"\",'Unit Costs'!C16)","v":""},{"$f":"IF('Unit Costs'!D16=\"\",\"\",'Unit Costs'!D16)","v":""},{"$f":"IF(C20=\"\",\"\",J8*8/3*155/2000)","v":""},""]
[{"$f":"IF('Unit Costs'!B17=\"\",\"\",'Unit Costs'!B17)","v":"Bridge/Culvert"},{"$f":"IF('Unit Costs'!C17=\"\",\"\",'Unit Costs'!C17)","v":"S.F."},{"$f":"IF('Unit Costs'!D17=\"\",\"\",'Unit Costs'!D17)","v":225},{"$f":"IF(C21=\"\",\"\",0)","v":0},0]
[{"$f":"IF('Unit Costs'!B18=\"\",\"\",'Unit Costs'!B18)","v":"Traffic Signal"},{"$f":"IF('Unit Costs'!C18=\"\",\"\",'Unit Costs'!C18)","v":"Each"},{"$f":"IF('Unit Costs'!D18=\"\",\"\",'Unit Costs'!D18)","v":180000},{"$f":"IF(C22=\"\",\"\",0)","v":0},0]
["Subtotal",null,null,null,{"$f":"(SUM(E9:E22))","v":230647.93503213959}]
[]
["Contingency",null,null,{"$f":"'Unit Costs'!C20","v":0.25},{"$f":"D25*E23","v":57661.983758034898}]
[]
["Mobilization",null,null,{"$f":"'Unit Costs'!C22","v":0.1},{"$f":"D27*E23","v":23064.793503213961}]
[]
["Preconstruction Engineering",null,null,{"$f":"'Unit Costs'!C24","v":0.08},{"$f":"D29*E23","v":18451.834802571168}]
["Construction Engineering",null,null,{"$f":"'Unit Costs'!C25","v":0.08},{"$f":"D30*E23","v":18451.834802571168}]
[]
["Total Project Costs",null,null,null,{"$f":"ROUNDUP(SUM(E23,E25,E27,E29:E30),-2)","v":348300}]
[]
[{"$f":"'Unit Costs'!B1&\"'s Responsibility Via Impact Fee's\"","v":"Provo's Responsibility Via Impact Fee's"},null,null,null,{"$f":"IF(VLOOKUP($A$5,Projects!$C$3:$E$103,3,FALSE)=DROPDOWNS!$D$5,0,IF(VLOOKUP($A$5,Projects!$C$3:$E$103,3,FALSE)=DROPDOWNS!$D$4,0.07,IF(VLOOKUP($A$5,Projects!$C$3:$E$103,2,FALSE)=DROPDOWNS!$B$7,1,IF(VLOOKUP($A$5,Projects!$C$3:$E$103,2,FALSE)=DROPDOWNS!$B$4,1,VLOOKUP($A$6,Assumptions!$C$3:$O$11,13,FALSE)))))","v":0.26638615391484843}]
[null,null,null,null,{"$f":"ROUND(E34*E32,-4)","v":90000}]
[]
[{"$f":"'Cross-Section Comparison'!A34:C34","v":"Overall Assumptions:"}]
[{"$f":"'Cross-Section Comparison'!A35:C35","v":"HMA Pavement Density (pcf) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,2,FALSE)","v":155}]
[{"$f":"'Cross-Section Comparison'!A36:C36","v":"HMA Thickness (in) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,3,FALSE)","v":4}]
[{"$f":"'Cross-Section Comparison'!A37:C37","v":"Untreated Base Course Thickness (in) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,4,FALSE)","v":8}]
[{"$f":"'Cross-Section Comparison'!A38:C38","v":"Granual Borrow Thickness (in) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,5,FALSE)","v":14}]
[{"$f":"'Cross-Section Comparison'!A39:C39","v":"Roadway Excavation Depth (ft) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,6,FALSE)","v":2.5}]
[{"$f":"'Cross-Section Comparison'!A40:C40","v":"Number of Sidewalks (No.) ="},{"$f":"VLOOKUP($A$6,Assumptions!$C$3:$N$11,7,FALSE)","v":2}]
[{"$f":"IF('Unit Costs'!B34=\"\",\"\",'Unit Costs'!B34)","v":""},{"$f":"IF('Unit Costs'!C34=\"\",\"\",'Unit Costs'!C34)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B35=\"\",\"\",'[1]Unit Costs'!B35)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B36=\"\",\"\",'[1]Unit Costs'!B36)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B37=\"\",\"\",'[1]Unit Costs'!B37)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B38=\"\",\"\",'[1]Unit Costs'!B38)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B39=\"\",\"\",'[1]Unit Costs'!B39)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B40=\"\",\"\",'[1]Unit Costs'!B40)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B42=\"\",\"\",'[1]Unit Costs'!B42)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B43=\"\",\"\",'[1]Unit Costs'!B43)","v":""}]
[{"$f":"IF('[1]Unit Costs'!B44=\"\",\"\",'[1]Unit Costs'!B44)","v":""}]